在上一篇介紹了使用EM建立physical standby，相信大家以愛上EM，但我還是得說明如何使用SQL來建置physical standby，畢竟這樣才能真正了解整個作業流程。
雖然這份文件在windows平台測試，和正式環境有差異(正式環境DG建置在R6 Unix平台)，不過建置過程其實大同小異，只需注意幾個重點:

1.小弟正式環境採ASM，所以須注意路徑(+DATADG)
2.修改*.ora參數檔,control file請勿填寫由ASM自行建立
3.如使用NFS需使用Oracle規定指令才能mount成功
4.請再三確認rman backup及flash_recovery_area size，以免白花時間在備份上

確認primary and standby archive log mode

修改 archive mode
Shutdown immediate;
Startup mount;
Alter database archivelog;
Alter database open;

開啟FlashBack on(建議standby )
alter database flashback on;
開啟 forced logging

建立physics standby control file
alter database create standby controlfile as 'F:\standbybk\sdbcontrol01.ctl';

建立primary init.ora

複製該檔等等做為physics standby sdb2.ora

修改 pridg.ora
pridg.__db_cache_size=436207616
pridg.__java_pool_size=4194304
pridg.__large_pool_size=4194304
pridg.__shared_pool_size=159383552
pridg.__streams_pool_size=0
*.audit_file_dest='D:\oracle\product\10.2.0/admin/pridg/adump'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/pridg/bdump'
*.compatible='10.2.0.2.0'
*.control_files='D:\oradata\pridg\control01.ctl'
*.core_dump_dest='D:\oracle\product\10.2.0/admin/pridg/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='pridg'
*.DB_UNIQUE_NAME='pridg'
*.DB_FILE_NAME_CONVERT='D:\oradata\pridg','D:\oradata\sdb2'
*.FAL_CLIENT='pridg'
*.FAL_SERVER='sdb2'
*.STANDBY_FILE_MANAGEMENT=AUTO
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(pridg,sdb2)'
*.LOG_ARCHIVE_DEST_1='LOCATION=D:\oradata\priarch
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=pridg'

*.LOG_ARCHIVE_DEST_2='SERVICE=sdb2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=sdb2'

*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.LOG_FILE_NAME_CONVERT='D:\oradata\priarch','D:\oradata\sdb2arch'
*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=pridgXDB)'
*.job_queue_processes=10
*.nls_language='TRADITIONAL CHINESE'
*.nls_length_semantics='CHAR'
*.nls_territory='TAIWAN'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=335
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\product\10.2.0/admin/pridg/udump'

由於字數限制請參考part2